Eric Law
Eric Law
Reactions
-
Re: how do I change the default output to blank if neither criteria is true
@WinaHath =IF(ISBLANK([Date of Last Invoice]@row), "", IF([Date of Last Invoice]@row < DATE(YEAR(TODAY()) - 2, MONTH(TODAY()), DAY(TODAY())), "Inactive", "Active"))1 · -
Re: Formula to analyse multi-select responses in a restricted drop down list
Hello @Naina Dave You can do a COUNTIF and CONTAINS for each data point. You can either have a roll up sheet that you put the data or use the summary tab to aggregate that data. Example for car: =COU…1 · -
Re: I need help with a formula. I want to mark overdue projects.
@Cristina W Try =IF([End Date]@row < TODAY(30), "Overdue") With the formula, you are capturing anything over 30 days past due or within 30 days?? If it is within the next 30 days, the fo…1 · -
Re: Help with IF/Then statement for values between 2 numbers
@K.Bisnett You're missing a comma which might affect it, also your time for midnight is wrong as you would get an error for less than 00:00:00. =IF(AND([Shift Start Time]@row >= "18:00:00&quo…1 · -
Re: Formula to pull selected text from a cell into a dropdown list.
@damon.tackett You'll need an AND statement to make it work, also your CONTAINS is backwards. =IF(AND(CONTAINS("BTS1", [Customer Order]@row), CONTAINS("BTS2", [Customer Order]@row…1 ·
